Gold Medal Software 2

home *** CD-ROM | disk | FTP | other *** search

/ Gold Medal Software 2 / Gold Medal Software Volume 2 (Gold Medal) (1994).iso / database / mvl38.arj / MANUAL.TXT < prev next >

Wrap

Text File | 1993-08-23 | 108KB | 2,778 lines

▓▓▓▓▓▓▓▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▓▓▓▌▓▓▓▌▓▓▓▓▓▓▌ ▓▓▓▌▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▌▓▓▓▌ ▓▓▓▌▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▌▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▌ ▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▓▓▓▌▓▓▓▌▓▓▓▓▓▓▌ A N D ▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▓▓▓▌ ▓▓▓▓▓▓▓▌▓▓▓▓▓▓▓▌ ▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▌▓▓▓▌ ▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▓▓▌ ▓▓▓▌▓▓▓▌ ▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▌▓▓▓▌ ▓▓▓▓▓▌ ▓▓▓▌▓▓▓▓▓▓▌ ▓▓▓▓▓▓▓▌▓▓▓▓▓▓▓▌ ▓▓▓▌ ▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▓▓▓▌ ▓▓▓▌ ▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▌ ▓▓▓▌▓▓▓▓▓▓▌ ▓▓▓▓▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▌ ▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▌ ▓▓▓▌▓▓▓▌▓▓▓▌▓▓▌ ▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌ ▓▓▓▓▓▓▌▓▓▓▌▓▓▓▓▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌▓▓▓▌ MUSIC & VIDEO LIBRARIAN V 3.8 Shareware Version Copyright 1993 Alpine Software Development TABLE OF CONTENTS Data Entry of Information . . . . . . . . . . . . . . . . . 6 Music Albums . . . . . . . . . . . . . . . . . . . . . . 7 Album Songs . . . . . . . . . . . . . . . . . . . . . . . 12 Video Library . . . . . . . . . . . . . . . . . . . . . . 15 Hi-Fi & Video Equipment . . . . . . . . . . . . . . . . . 21 Radio Station Directory . . . . . . . . . . . . . . . . . 25 Reporting . . . . . . . . . . . . . . . . . . . . . . . . . 29 Music Reports . . . . . . . . . . . . . . . . . . . . . . 30 Album Report by Title . . . . . . . . . . . . . . . . . 31 Album Report by Artist . . . . . . . . . . . . . . . . 32 Album Report By Song . . . . . . . . . . . . . . . . . 33 Video Reports . . . . . . . . . . . . . . . . . . . . . . 34 Video Library Full Report . . . . . . . . . . . . . . . 35 Video Library by Star . . . . . . . . . . . . . . . . . 36 Hi-Fi Equipment Reports . . . . . . . . . . . . . . . . . 37 Equipment list by Description . . . . . . . . . . . . . 38 Equipment list by type . . . . . . . . . . . . . . . . 39 Radio Station Reports . . . . . . . . . . . . . . . . . . 40 Radio stations by station call . . . . . . . . . . . . 41 Radio stations by frequency . . . . . . . . . . . . . . 42 Tables . . . . . . . . . . . . . . . . . . . . . . . . . . 43 Media Validation Table . . . . . . . . . . . . . . . . . 44 Category Validation Table . . . . . . . . . . . . . . . . 46 Utilities . . . . . . . . . . . . . . . . . . . . . . . . . 48 Free Form Report Generator . . . . . . . . . . . . . . . 49 Reorganize/Sort . . . . . . . . . . . . . . . . . . . . . 52 Set Screen Colors . . . . . . . . . . . . . . . . . . . . 53 Set Printer . . . . . . . . . . . . . . . . . . . . . . . 55 Manual/Registration . . . . . . . . . . . . . . . . . . . . 60 View/Print Manual . . . . . . . . . . . . . . . . . . . . 61 View/Print Registration . . . . . . . . . . . . . . . . . 62 Options . . . . . . . . . . . . . . . . . . . . . . . . . . 63 Help Topics . . . . . . . . . . . . . . . . . . . . . . . 65 Music & Video Librarian V 3.8 Page 1 ====================================================================== The Music and Video Librarian is an application designed for people who collect videos (can be tapes, lasers, or even filem) and music to keep track of there collections. Simple and straight forward menuing software allows you to add or update records in the system using arrow keys and function keys to all the features of the system. Many standard reports are provided in different sequences to list items from the files. We have also included in the software a Free Form Report generator which will allow you to design, run and save your own reports. Features ======== - Simple to use pull down menus and pop-up windows - Context sensitive help available on all screens - Organize Music collections - Organize Video collections - Maintain accurate information about your audio and videl equipment - Record information about your local radio stations - Each album can contain an many songs (tracks) as needed as the only limitation is the size of your hard drive. - Up to 16 million entries can be entered into each of the databases. - Up to 64000 characters of information can be recorded for each song. Wh have provided this feature for those users whold like to store additional information such as all the musicians who played the song or the words in the song. - Locating records is easy using the menus. - Print options allow you to print on any printer that may be available. Provided standard are the printer setups for HP, IBM and several others. - Many standard reports are provided. If you have specific requirements then you can use the Free Form Report generator and design your own. - Complete tools are provided to manage your files and keep Page 2 Music & Video Librarian V 3.8 ====================================================================== them performing at there best. - Fully configurable including screen color selection, printer setup and more. Installation ============ Please see the accompanying documentation for complete installation instructions. System Requirements =================== MS/DOS or PC/DOS 3.1 or higher At least 1mb minimum hard disk space. Actual amount will depend on the size of the various collections. Any standard printer including HP laser. One floppy drive either 3 1/2 or 5 1/4 any density. Limitations =========== There are no real limitations in this software. You may store as much information as you like and are only limited by the amount of hard disk space you have. Each of the Files may contain a maximum of 16 million records which should be plenty for most users (were sorry that those users with over 16 million albums will not be able to use this software). In this version only the Free Form report generator may print to a network (Novell) printer. If you would like full network (Novell) support contact us for special pricing. Initial SignOn ============== The first time you start up the Music and Video Librarian it will ask you for your registered name. Please enter your name as it will be used on screens and reports. The following is a sample of this signon screen: ╓─────────────────────────────────────────────────────────────╖ ║ Initial Installation ║ ║ ║ ║ Registered User: ║ ╙─────────────────────────────────────────────────────────────╜ Music & Video Librarian V 3.8 Page 3 ====================================================================== Invoking the Music and Video Librarian ====================================== To start up the program enter the following commands at the C prompt: CD MVLIB MIM or MT M (for monochrome monitors) The first command will change to the directory where you installed the software and the second command will start the program. After several seconds (depending on the speed of your machine) you will see the welcome screen. Press enter 2 times and the menus will appear at the top of the screen. Browsing The Files ================== As you begin to add records to the various files the software will automatically put you into a browse mode (when there is at least one record). The following is an example of the browse screen for the Vendor Table: ╔═════════════════════════════════════════════════════╗ ║ Music Albums File ║ ╠════════════╤════════════════════════════════════════╣ ║Album Number│ Title of Album ║ ╟────────────┼────────────────────────────────────────╢ ║ 10│Long Distance Voyager ║ ║ 20│In Search of the Lost Cord ║ ║ 30│Eye In The Sky ║ ║ 40│Fresh Aire I ║ ║ 50│The Turn of a Friendly Card ║ ║ │ ║ ║ │ ║ ║ │ ║ ╚════════════╧════════════════════════════════════════╝ Page 4 Music & Video Librarian V 3.8 ====================================================================== By using the up and down arrow keys you can move to different records in the file. Using the [PGUP] and [PGDN] keys you can move a full screen at a time (about 16 records), and using [Alt PGUP] or [Alt PGDN] you can move to the first record or last record in the file. When you have found the record you would like to view or change (indicated by highlighting) press the enter key. The record will now be displayed. Also note at the bottom of the screen there is a field used for searching. If you have a large file you can use this field to position the highlighted item to a range of records. For example if you are in the MUSIC file and have used the select key (see below) for Title of Album and you are looking for "Long Distance Voyager" then enter into this field "Lon" or "Long" or" Long D" and the highlighted item will be the first item. You can use this feature to move quickly through the files. If you would like to view records in a different order press the [F10] key and a small menu will appear at the lower right hand corner of the screen giving you the choices for the file you are browsing. The following example illustrates the alternates for the Music file: ┌──>Select Key<──┐ │ Album Number │ │ Title of Album │ │ Artist or Group│ └────────────────┘ Each file in Music and Video Librarian has different selection keys so you will need to experiment as to what select keys are best for you. Screen Saver ============ After 2 minutes of inactivity the software will display the following screen: ┌──────────────────────────────┐ │ The screen has been saved │ │ Press the spacebar to resume │ └──────────────────────────────┘ This box will move around the screen in a random pattern until such time as you press the space key at which time you will return back to the same screen you were at. Music & Video Librarian V 3.8 Page 5 ====================================================================== Special Keys used on menus ========================== [INS] The Insert key is used to add new records to the file selected. [DEL] The delete key is used to delete the currently selected (highlighted - reverse video) record [ENTER] Pressing enter will select the current item for processing (i.e. editing or running reports) [PgUp] Move one screen at a time towards the top (i.e. during a browse of a file) [PgDn] Move one screen at a time towards the bottom (i.e. during a browse of a file) [HOME] Go to the top item or record [END] Go to the bottom item or record [ESC] End (or exit) the current function [F1] Displays context sensitive help (Context sensitive help will display information about the function, field, or area in the program you are in). [F2] Displays the Help Topics file that will give you all of the documentation for Hardwaree Software Information System online. [F6] Will bring up the screen to select the SYSTEM options (name, address, etc). [F10] During browse of a database this function key will display a list of secondary indexed that can be used to select records from. Special Keys used during edit ============================= [up] Go up one field [down] Go down one field [HOME] Go to the first field [END] Go to the last field [ENTER] Go to the next field [ESC] End (or exit) the current function Page 6 Music & Video Librarian V 3.8 ====================================================================== Data Entry of Information ========================= This is the menu that you will used to select the various files for data entry (adding, changing, or deleting records) from the Music and Video Librarian. Up selecting this menu item the following menu will appear: ╔═══════════════════════════╗ ║ Music Albums ║ ║ Album Songs ║ ║ Video Library ║ ║ Hi-Fi & Video Equipment ║ ║ Radio Station Directory ║ ╚═══════════════════════════╝ The first menu item under the DATA ENTRY item is Music Albums. the Music and Video Librarian has an originization for keeping Musci records together and can be summarized as follows: To add album songs to a music album there must be a corresponding Music record in the Music Album file before the record can be added. To delete a Album record ALL of the Album Songs must be deleted from the Album Song file. Music & Video Librarian V 3.8 Page 7 ====================================================================== Music Albums ============ ╔════════════════════════════════════════════════════════════════════════╗ ║ Album Information ║ ╟────────────────────────────────────────────────────────────────────────╢ ║ Album Id.. ■■■■■■ ║ ║ ║ ║ Title..... ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ Artist.... ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ ║ ║ Media..... ■■ Category.... ■■■■■ ║ ╟────────────────────────────────────────────────────────────────────────╢ ║ ║ ║ Date Purch ■■■■■■■■ Cost........ ■■■■■■ ║ ║ ║ ║ Label..... ■■■■■■■■■■■■■■■■■■■■ ║ ║ Label Id.. ■■■■■■■■■■ ║ ║ Year...... ■■■■ Comments..... ■■■■■■■■■■ ║ ║ ║ ║ Tracks.... ■■■■■■■■■■ ║ ╚════════════════════════════════════════════════════════════════════════╝ This is the screen used to make changes to the album file. TO RETURN TO PREVIOUS SCREEN Press <ESC> until a pop-up appears and asks you if you want to EXIT. Pressing <ESC> from any screen in the program will get you back to the previous screen. To exit ir quit the program press <ESC> until you are prompted to exit the program. Selecting this menu option brings up a browse window. If the file is empty, you will automatically be put into a screen for adding your first record. But let's start with the browse window. You only see the first couple of fields when it comes up. By pressing the Arrow keys you can move to the right, left, down, or up in order to see all the records and fields in your databases. Page up, down, home , and end will also move you through the window. While in the Browse you can change the order your data is presented in (we call this indexing). Press F10 to see a pop-up of the indexes available. Use the arrow keys to highlight the one you want and press <Enter>. You can use the arrow keys to move to the field containing the index condition before or after you select the new index. If you want to search for the name of a Page 8 Music & Video Librarian V 3.8 ====================================================================== user, index on the user's name and type in some or all of it. Then press <Enter>. If you only typed in a few letters of the name ('stu', for example), the program will seek the first person whose name starts with 'Stu'. The same hold true for all the indexes. ADDING A RECORD <INS>:..Use the Insert key when you want to add a record to your files. This will open a screen to enter your data. EDITING A RECORD <Enter>:..First highlight the record you wand to edit and press <Enter>. The screen will look different than when you add a record. An '==>' is visible at the first field. Using the arrow keys move to the field you want to edit and press <Enter>. This will allow you to edit the field. Press <Enter> again and the '==>' will re-appear. Edit all the fields you need and press <ESC> to accept, re-try, or cancel you edits. DELETING A RECORD <DEL>:..Highlight the record you want to delete and press the <DEL> key. The following fields are contained in the Album database: Album Number ------------ Format: 6 position character field Contents: This field is a mandatory field used to identify each of your albums. There is no specific format for this filed so we suggest that you develop a scheme for numbering your collection. Consider the following example: 1xxxxx Used for rock albums 2xxxxx Used for Jazz albums 3xxxxx Used for all other albums 9xxxxx Used for rare albums where xxxxx is a number staring with 00001 and is incremented by +1 for each album. Music & Video Librarian V 3.8 Page 9 ====================================================================== Title of Album -------------- Format: 35 position character field Contents: Enter the title or the name of the album as it appears on the album cover. If the name starts with a word such as "The Best...." then we suggest that you code the title as "Best...., The" so that when you product reports by title they will be ordered properly. Artist or Group --------------- Format: 40 position character field Contents: Enter either the primary artist of the group who performed this album. Album Media ----------- Format: 12 position character field Contents: Enter the album media for this album. Pressing enter is this field will pop up a menu of default media's that you can select from by moving the up and down arrow keys. When you find the media you desire press enter and it will be placed into the field for you. The following media's came as default with the software: ALBUM CD DAT EP SINGLE 45 78 CASETTE TAPE OTHER You can add additional entries either by entering the new category in this field or by using the TABLES menu and selecting MEDIA. Please refer to the Page 10 Music & Video Librarian V 3.8 ====================================================================== MEDIA later in this manual on how to add change or delete records from this file. Category of Music ----------------- Format: 12 position character field Contents: Enter the music catagory for this album. Pressing enter is this field will pop up a menu of default categories that you can select from by moving the up and down arrow keys. When you find the catageory you desire press enter and it will be placed into the field for you. The following categories came as default with the software: ROCK JAZZ FUSION POPULAR NEW WAVE CLASSICAL SOUND TRACK COUNTRY VINTAGE You can add additional entries either by entering the new category in this field or by using the TABLES menu and selecting CATEGORY. Please refer to the category later in this manual on how to add change or delete records from this file. Date Purchased -------------- Format: 8 position date field Contents: Enter the date you purchased this album in the format of MM/DD/YY. Example 08/15/93. Cost of Album ------------- Music & Video Librarian V 3.8 Page 11 ====================================================================== Format: 6 position numeric field (format nnn.nn Contents: Enter the cost you paid for this album in dollars and cents. Example 14.95. You do not need to enter the dollar ($) sign. Album Label ----------- Format: 20 position character field Contents: Enter the recording label as it appears on the label of the album. Album Identification -------------------- Format: 10 position character field Contents: This field is used to record the manufactures album identification number. Year Released ------------- Format: 4 position numeric field Contents: The year the album was released. Do not confuse the year with the copyright year as they may be different. Some groups perform in one year and release there album the next. Page 12 Music & Video Librarian V 3.8 ====================================================================== Album Songs =========== ┌───────────────────────────────────────────────┐ │ Songs by Track │ ├───────────────────────────────────────────────┤ │ Track... ■■ │ │ │ │ Title... ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ │ │ │ │ Time.... ■■:■■ │ │ │ │ Misc.... ■■■■■■■■■■ │ └───────────────────────────────────────────────┘ The Songs by Track file is used to record track information about each track on an Album. This is an optional file and is not required for successfull use. The following guidelines will help you use this file: TO RETURN TO PREVIOUS SCREEN Press <ESC> until a pop-up appears and asks you if you want to EXIT. Pressing <ESC> from any screen in the program will get you back to the previous screen. To exit ir quit the program press <ESC> until you are prompted to exit the program. Selecting this menu option brings up a browse window. If the file is empty, you will automatically be put into a screen for adding your first record. But let's start with the browse window. You only see the first couple of fields when it comes up. By pressing the Arrow keys you can move to the right, left, down, or up in order to see all the records and fields in your databases. Page up, down, home , and end will also move you through the window. While in the Browse you can change the order your data is presented in (we call this indexing). Press F10 to see a pop-up of the indexes available. Use the arrow keys to highlight the one you want and press <Enter>. You can use the arrow keys to move to the field containing the index condition before or after you select the new index. If you want to search for the name of a user, index on the user's name and type in some or all of it. Then press <Enter>. If you only typed in a few letters of the name ('stu', for example), the program will seek the first person whose name starts with 'Stu'. The same hold true for all the indexes. Music & Video Librarian V 3.8 Page 13 ====================================================================== ADDING A RECORD <INS>:..Use the Insert key when you want to add a record to your files. This will open a screen to enter your data. EDITING A RECORD <Enter>:..First highlight the record you wand to edit and press <Enter>. The screen will look different than when you add a record. An '==>' is visible at the first field. Using the arrow keys move to the field you want to edit and press <Enter>. This will allow you to edit the field. Press <Enter> again and the '==>' will re-appear. Edit all the fields you need and press <ESC> to accept, re-try, or cancel you edits. DELETING A RECORD <DEL>:..Highlight the record you want to delete and press the <DEL> key. Track Number ------------ Format: 3 position Numeric field Contents: We have provided a 3 position field here to be used to contain the side and track number. For example vinal records have 2 sides each with any number of tracks: 101 - side 1 track 1 103 - side 1 track 3 204 - side 2 track 4 For newer CD type media simply use the track number starting with 1. Track Title ----------- Format: 30 position character field Contents: The full title of the song for this track. Track Minutes ------------- Page 14 Music & Video Librarian V 3.8 ====================================================================== Format: 2 position numeric field Contents: The number of minuted for this song or track. The next field is used to record the seconds. Track seconds ------------- Format: 2 position numreic field Contents: The number of partial seconds for the song or track. Music & Video Librarian V 3.8 Page 15 ====================================================================== Video Library ============= ╔═════════════════════════════════════════════════════════════════╗ ║ Video Tape Library ║ ╟─────────────────────────────────────────────────────────────────╢ ║ Tape No..... ■■■■■■ ║ ║ Title....... ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ Category.... ■■■■■■■■■■■■■■■ ║ ║ Color/BW.... ■ Cost... ■■■■■■■■ Rating.... ■■■■■■■■■■ ║ ╟─────────────────────────────────────────────────────────────────╢ ║ Storage Loc. ■■■■■■■■■■ Loaned to. ■■■■■■■■■■■■■■■■■■■■ ║ ╟─────────────────────────────────────────────────────────────────╢ ║ Time........ ■■■ Speed... ■■ Start..... ■■■■ End... ■■■ ║ ╟─────────────────────────────────────────────────────────────────╢ ║ Desc........ ║ ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ Stars....... ║ ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ Director.... ║ ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ╚═════════════════════════════════════════════════════════════════╝ This section is used to record information about your video collection. The material that you record can be about any type of videos. A number of standard reports are provided to list out information from the videos file. If you do not like the format of the reports we have supplied you can design your own using the free format report generator described elsewhere in this manual. TO RETURN TO PREVIOUS SCREEN Press <ESC> until a pop-up appears and asks you if you want to EXIT. Pressing <ESC> from any screen in the program will get you back to the previous screen. To exit ir quit the program press <ESC> until you are prompted to exit the program. Selecting this menu option brings up a browse window. If the file is empty, you will automatically be put into a screen for adding your first record. But let's start with the browse window. You only see the first couple of fields when it comes up. By pressing the Arrow keys you can move to the right, left, down, or up in order to see all the records and fields in your databases. Page up, down, home , and end will also move you through the Page 16 Music & Video Librarian V 3.8 ====================================================================== window. While in the Browse you can change the order your data is presented in (we call this indexing). Press F10 to see a pop-up of the indexes available. Use the arrow keys to highlight the one you want and press <Enter>. You can use the arrow keys to move to the field containing the index condition before or after you select the new index. If you want to search for the name of a user, index on the user's name and type in some or all of it. Then press <Enter>. If you only typed in a few letters of the name ('stu', for example), the program will seek the first person whose name starts with 'Stu'. The same hold true for all the indexes. ADDING A RECORD <INS>:..Use the Insert key when you want to add a record to your files. This will open a screen to enter your data. EDITING A RECORD <Enter>:..First highlight the record you wand to edit and press <Enter>. The screen will look different than when you add a record. An '==>' is visible at the first field. Using the arrow keys move to the field you want to edit and press <Enter>. This will allow you to edit the field. Press <Enter> again and the '==>' will re-appear. Edit all the fields you need and press <ESC> to accept, re-try, or cancel you edits. DELETING A RECORD <DEL>:..Highlight the record you want to delete and press the <DEL> key. Tape No ------- Format: 6 Character numeric field Contents: This field is used to contain a reference tape number that is used for identification of tapes. You should place a sticker on the outside of the tape with this number and file the tapes in sequence. Video Title ----------- Format: 40 Character field (not required) Contents: Use this field to enter the title of the video Music & Video Librarian V 3.8 Page 17 ====================================================================== Category -------- Format: 6 position character field (must have an entry in the Category table) Contents: This field will allow you to group your videos into different categories. Some examples might include: COMEDY For Comides DRAMA For Drama NOTE: To add a new category code you may either go to the TABLE menu and select category and add the new code there or enter the new code in this field and a screen will appear for you to add it here. Which ever you use will bring the same results. Color/BW -------- Format: 1 position character field (free form) Contents: This field is used to distinguish between color and black and white videos. Suggest using the following: C = Color B = Black and White Cost ---- Format: 8 position numeric field (format 99999.99) Contents: Enter the original cost YOU paid for the video in dollars and cents (24.95). Rating ------ Page 18 Music & Video Librarian V 3.8 ====================================================================== Format: 5 position character field (free form) Contents: Enter the standard movie rating for this video. Examples: G PG PG13 R N/R Storage Location ---------------- Format: 10 position character field Contents: Use this field to record the storage location of where the video is located. Some examples include: C1S1 Cabinet 1 shelf 1 ONLOAN Loaned out CLOSET Loaned To --------- Format: 30 position character field (free form) Contents: When you load your videos out to friends use this field to record there name and maybe the date you loaned out the video. Suggest that you use last name first followed by the first name as this will simplify generating reports. Running time ------------ Format: 4 position numeric field (free form) Contents: Enter the total running time of the video. Speed ----- Format: 2 position character field (free form) Music & Video Librarian V 3.8 Page 19 ====================================================================== Contents: Enter the 2 character video tape speed. Starting Counter ---------------- Format: 4 position numeric field (free form) Contents: This field is used to record the starting counter for those tapes that have several movies on them. If this is a single video tape then this field may be left blank. Ending Position --------------- Format: 4 position numeric field (free form) Contents: This field is used to record the ending counter for those tapes that have several movies on them. If this is a single video tape then this field may be left blank. Description (1) --------------- Format: 59 position character field Contents: This is the first of two free form fields we have provided to contain additional descriptive information about the videos. Some examples for the use of this field include: 1. Additional stars 2. Plot of movie 3. Things like location and subjects Description (2) --------------- Format: 59 position character field Contents: This is the second of two free form fields we have provided to contain additional descriptive information about the videos. Some examples for the use of this field include: 1. Additional stars Page 20 Music & Video Librarian V 3.8 ====================================================================== 2. Plot of movie 3. Things like location and subjects Stars ----- Format: 30 position character field (free form) Contents: Enter the name(s) of the people who star in this film. Suggest that you use last name first followed by the first name as this will simplify generating reports by Director. Director -------- Format: 20 position character field (free form) Contents: Enter the name of the person who directed the film. Suggest that you use last name first followed by the first name as this will simpilfy generating reports by Director. Music & Video Librarian V 3.8 Page 21 ====================================================================== Hi-Fi & Video Equipment ======================= ╔═══════════════════════════════════════════════════════════╗ ║ Hi-Fi & Video Equipment Inventory ║ ╟───────────────────────────────────────────────────────────╢ ║ Description...... ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ Make............. ■■■■■■■■■■■■■■■■■■■■ ║ ║ Equipment Type... ■■■■■■■■■■■■■■■ ║ ║ Model............ ■■■■■■■■■■■■■■■ ║ ║ Serial No........ ■■■■■■■■■■■■■■■ ║ ╟───────────────────────────────────────────────────────────╢ ║ Date Purchased... ■■■■■■■■ ║ ║ Price Paid....... ■■■■■■■ ║ ║ Current Value.... ■■■■■■■ ║ ║ Valued Date...... ■■■■■■■■ ║ ╚═══════════════════════════════════════════════════════════╝ The equipment database has been provided for you to keep track of all the audio and video components you have. When adding records to this file don't forget to add those small items such as cables, batteries, camera cases, etc. The following guidelines will help you use this file: TO RETURN TO PREVIOUS SCREEN Press <ESC> until a pop-up appears and asks you if you want to EXIT. Pressing <ESC> from any screen in the program will get you back to the previous screen. To exit ir quit the program press <ESC> until you are prompted to exit the program. Selecting this menu option brings up a browse window. If the file is empty, you will automatically be put into a screen for adding your first record. But let's start with the browse window. You only see the first couple of fields when it comes up. By pressing the Arrow keys you can move to the right, left, down, or up in order to see all the records and fields in your databases. Page up, down, home , and end will also move you through the window. While in the Browse you can change the order your data is presented in (we call this indexing). Press F10 to see a pop-up of the indexes available. Use the arrow keys to highlight the one you want and press <Enter>. You can use the arrow keys to move to the field containing the index condition before or after you select the new index. If you want to search for the name of a user, index on the user's name and type in some or all of it. Page 22 Music & Video Librarian V 3.8 ====================================================================== Then press <Enter>. If you only typed in a few letters of the name ('stu', for example), the program will seek the first person whose name starts with 'Stu'. The same hold true for all the indexes. ADDING A RECORD <INS>:..Use the Insert key when you want to add a record to your files. This will open a screen to enter your data. EDITING A RECORD <Enter>:..First highlight the record you wand to edit and press <Enter>. The screen will look different than when you add a record. An '==>' is visible at the first field. Using the arrow keys move to the field you want to edit and press <Enter>. This will allow you to edit the field. Press <Enter> again and the '==>' will re-appear. Edit all the fields you need and press <ESC> to accept, re-try, or cancel you edits. DELETING A RECORD <DEL>:..Highlight the record you want to delete and press the <DEL> key. Equipment Description --------------------- Format: 30 position character field Contents: Enter a brief description of item. Other fields are provided for make, model and serial number. Make of Equipment ----------------- Format: 20 position character field Contents: Enter the make or the manufacture of the equipment. Equipment type -------------- Music & Video Librarian V 3.8 Page 23 ====================================================================== Format: 15 position character field Contents: Enter the type of equip this is. Consider the following examples: VCR Tuner Camera Model of Equipment ------------------ Format: 15 position character field Contents: Enter the model of the equipment. Often this can be found on the sticker that has the serial number on it. Serial Number ------------- Format: 15 position character field Contents: Enter the equipments serial number. On some components there is a sticker on the bottom or back, and on others it is stamped on the case. Date Purchased -------------- Format: 8 position date field (format MM/DD/YY) Contents: Enter the date you purchased the item. This date should be the same date that is on the sales reciept if you are saving sales reciepts (and we suggest that you keep these in a safe place). Cost of Equipment ----------------- Format: 7 position numeric field Contents: This field should contain the original cost you paid for the item and not the current value. We have another field for this purpose. Page 24 Music & Video Librarian V 3.8 ====================================================================== Current Value ------------- Format: 7 position numeric field Contents: If you have an idea of how much this item is worth enter that value in this field and enter todays date in the Date Of Value Field. Date of value ------------- Format: 8 position date field (format MM/DD/YY) Contents: If you have estimated the value for this item and entered that value in the Current Value field enter the date you estimated it here. Music & Video Librarian V 3.8 Page 25 ====================================================================== Radio Station Directory ======================= ╔═══════════════════════════════════════════════════════════╗ ║ Radio Station Information ║ ╟───────────────────────────────────────────────────────────╢ ║ Station Call... ■■■■ ║ ║ ║ ║ Address........ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ City........... ■■■■■■■■■■■■■■■■■■■■■■■■■ ST. ■■ ║ ║ ║ ║ Phone.......... ■■■■■■■■■■■■■■■ ║ ║ ║ ║ Station Format. ■■■■■■■■■■■■■■■■■■■■ ║ ║ ║ ║ Frequency...... ■■■■■■■■ ║ ╚═══════════════════════════════════════════════════════════╝ The radio station directory is used to assist you in locating radio stations in your area. To implement this feature we suggest that you buy your local Sunday paper and find the radio station directory in the entertanment section. As you gain additional knowledge about the stations you can update this file. This file can also be used to locate a specific type of programming. The following guidelines will help you use this file: TO RETURN TO PREVIOUS SCREEN Press <ESC> until a pop-up appears and asks you if you want to EXIT. Pressing <ESC> from any screen in the program will get you back to the previous screen. To exit ir quit the program press <ESC> until you are prompted to exit the program. Selecting this menu option brings up a browse window. If the file is empty, you will automatically be put into a screen for adding your first record. But let's start with the browse window. You only see the first couple of fields when it comes up. By pressing the Arrow keys you can move to the right, left, down, or up in order to see all the records and fields in your databases. Page up, down, home , and end will also move you through the window. While in the Browse you can change the order your data is presented in (we call this indexing). Press F10 to see a pop-up of the indexes available. Use the arrow keys to highlight the one you want and press <Enter>. You can use the arrow keys to move to Page 26 Music & Video Librarian V 3.8 ====================================================================== the field containing the index condition before or after you select the new index. If you want to search for the name of a user, index on the user's name and type in some or all of it. Then press <Enter>. If you only typed in a few letters of the name ('stu', for example), the program will seek the first person whose name starts with 'Stu'. The same hold true for all the indexes. ADDING A RECORD <INS>:..Use the Insert key when you want to add a record to your files. This will open a screen to enter your data. EDITING A RECORD <Enter>:..First highlight the record you wand to edit and press <Enter>. The screen will look different than when you add a record. An '==>' is visible at the first field. Using the arrow keys move to the field you want to edit and press <Enter>. This will allow you to edit the field. Press <Enter> again and the '==>' will re-appear. Edit all the fields you need and press <ESC> to accept, re-try, or cancel you edits. DELETING A RECORD <DEL>:..Highlight the record you want to delete and press the <DEL> key. Station Call ------------ Format: 4 position character field Contents: Enter the FCC radio station call sign. This field will be converted to all capital letters for you (koai becomes KOAI). Address Line 1 -------------- Format: 30 position character field Contents: Enter the first line of address where the radio station is located. Address line 2 -------------- Music & Video Librarian V 3.8 Page 27 ====================================================================== Format: 30 position character field Contents: Enter the second line of address where the radio station is located. City ---- Format: 25 position character field Contents: Enter the city where the redio station is located in State ----- Format: 2 position character field Contents: Enter the state where the redio station is located in Primary Phone No. ----------------- Format: 15 position character field Contents: Enter the primary phone number of the radio station. Station Format -------------- Format: 20 position character field Contents: This is a free form field used to record the format of music this station has. Consider the following: Country Music Jazz Rock News Classical Frequency --------- Format: 8 position numeric field Contents: Enter the frequency (where the station can be found on the dial) code here. For FM stations Page 28 Music & Video Librarian V 3.8 ====================================================================== frequency can be entered as 100.5 or 107.1 Music & Video Librarian V 3.8 Page 29 ====================================================================== Reporting ========= All of the standard "canned" reports can be found under this menu item. When you select this menu item the following menu will appear: ╔════════════════════════╗ ║ Music Reports ║ ║ Video Reports ║ ║ Hi-Fi Equipment Reports║ ║ Radio Station Reports ║ ╚════════════════════════╝ As you select different files you will be given a choice as to the order or sorting sequence for that report. If you find that our standard reports are not giving you the data you need for a particular purpose then we have provided the Free Form Report Generater which will enable you to design and run your own reports. This function can be found under the Utilities Menu option. One final note. If you have some suggestions for additional reports please drop us a line with your ideas and we will take them into consideration on future releases of the software. Page 30 Music & Video Librarian V 3.8 ====================================================================== Music Reports ============= The standard music reports can be selected from this menu item. When selected the following menu appears: ╔════>Music Reports<════╗ ║ Album Report by Title ║ ║ Album Report by Artist║ ║ Album Report By Song ║ ╚═══════════════════════╝ Both album and album with songs are printed from here. There is not a seperate menu for just songs. If you do not like the format of these reports you can design your own using the free format report generator described elsewhere in this manual. Music & Video Librarian V 3.8 Page 31 ====================================================================== Album Report by Title ===================== Report: Album Report by Title Description: This report contains a list of all items from the Album file sorted by Album title. Fields: Album Title Artist Date recorded Label Media Category Features: This is an abbreviated report that shows you all of the albums that you have in your collection. Print this report frequently and take it to the music store with you to assist in finding new albums. Page 32 Music & Video Librarian V 3.8 ====================================================================== Album Report by Artist ====================== Report: Album Report by Artist Description: This report contains a list of all items from the Album file sorted by Artist. Fields: Artist Album Title Media Category Label Label ID Features: This is an abbreviated report that shows you all of the albums that you have in your collection. ordered by artist. Music & Video Librarian V 3.8 Page 33 ====================================================================== Album Report By Song ==================== Report: Album Report with Song Information Description: This report contains a list of all items from the Album file sorted by Album title. For each album listed the corresponding Song information is also listed. Fields: Album Title Artist Date recorded Label Media Category Track Track Title Track Time Features: This is an full report that shows you all the albums and all the songs that are on those albums. Page 34 Music & Video Librarian V 3.8 ====================================================================== Video Reports ============= The standard Video reports can be selected from this menu item. When selected the following menu appears: ╔═════>Video Reports<══════╗ ║ Video Library Full Report║ ║ Video Library by Star ║ ╚══════════════════════════╝ If you do not like the format of the reports you can design your own using the free format repcrt generator described elsewhere in this manual. Music & Video Librarian V 3.8 Page 35 ====================================================================== Video Library Full Report ========================= Report: Video Report By Title Description: This report contains a list of all items from the Vidoe file sorted by Title. Fields: Title Description Stars Director Rating Features: This report shows you all the information in the Video file. Page 36 Music & Video Librarian V 3.8 ====================================================================== Video Library by Star ===================== Report: Video Report By Star Description: This report contains a list of all items from the Vidoe file sorted by Star. Fields: Star Title Description Director Rating Features: This report shows you all the information in the Video file. Music & Video Librarian V 3.8 Page 37 ====================================================================== Hi-Fi Equipment Reports ======================= hi fi reports ╔══>Hi-Fi Equipment Reports<═══╗ ║ Equipment list by Description║ ║ Equipment list by type ║ ╚══════════════════════════════╝ Page 38 Music & Video Librarian V 3.8 ====================================================================== Equipment list by Description ============================= Report: Equipment Listing by Description Description: This report contains a list of all items from the EQUIPMENT file sorted by Description. Fields: Description Make Equipment Type Model Serial number Date Purchased Cost Date of current value Current value Features: This report shows you all the information in the equipment file and is a master listing of all of your equipment. This report should be given to your insurnace agent if they require a special rider on your policy. Also you should keep this report in a safe place (safety box). Music & Video Librarian V 3.8 Page 39 ====================================================================== Equipment list by type ====================== Report: Equipment Listing by Equipment Type Description: This report contains a list of all items from the EQUIPMENT file sorted by Equipment type. Fields: Equipment Type Description Make Model Serial number Date Purchased Cost Date of current value Current value Features: This report shows you all the information in the equipment file. Page 40 Music & Video Librarian V 3.8 ====================================================================== Radio Station Reports ===================== radio station reports ╔════>Radio Station Reports<════╗ ║ Radio stations by station call║ ║ Radio stations by frequency ║ ╚═══════════════════════════════╝ Music & Video Librarian V 3.8 Page 41 ====================================================================== Radio stations by station call ============================== Report: Radio Station Report by Station Call Description: This report contains a list of all items from the RADIO file sorted by Station Call. Fields: Station call Frequency Address Phone Features: This report shows you all the information in the Radio Station file. Page 42 Music & Video Librarian V 3.8 ====================================================================== Radio stations by frequency =========================== Report: Radio Station Report by Frequency Description: This report contains a list of all items from the RADIO file sorted by Frequency. Fields: Frequency Station Call Address Phone Features: This report shows you all the information in the Radio Station file. Music & Video Librarian V 3.8 Page 43 ====================================================================== Tables ====== The tables included with Music and Video Librarian are the heart to insuring that information is entered into the various files consistantly. When this menu item is selected the following menu will apear: ╔══════════════════════════╗ ║ Media Validation Table ║ ║ Category Validation Table║ ╚══════════════════════════╝ In this version three tables are included as follows: MEDIA Used to validate the Media field in the Album file. CATEGORY Used to validate the Category field in the Album file. Page 44 Music & Video Librarian V 3.8 ====================================================================== Media Validation Table ====================== ╔════════════════════════════════╗ ║ Media Table Maintenance ║ ╟────────────────────────────────╢ ║ ║ ║ Media Code.... ■■■■■■■■ ║ ╚════════════════════════════════╝ This is the screen used to make changes to the Media Table. TO RETURN TO PREVIOUS SCREEN Press <ESC> until a pop-up appears and asks you if you want to EXIT. Pressing <ESC> from any screen in the program will get you back to the previous screen. To exit ir quit the program press <ESC> until you are prompted to exit the program. Selecting this menu option brings up a browse window. If the file is empty, you will automatically be put into a screen for adding your first record. But let's start with the browse window. You only see the first couple of fields when it comes up. By pressing the Arrow keys you can move to the right, left, down, or up in order to see all the records and fields in your databases. Page up, down, home , and end will also move you through the window. While in the Browse you can change the order your data is presented in (we call this indexing). Press F10 to see a pop-up of the indexes available. Use the arrow keys to highlight the one you want and press <Enter>. You can use the arrow keys to move to the field containing the index condition before or after you select the new index. If you want to search for the name of a user, index on the user's name and type in some or all of it. Then press <Enter>. If you only typed in a few letters of the name ('stu', for example), the program will seek the first person whose name starts with 'Stu'. The same hold true for all the indexes. ADDING A RECORD <INS>:..Use the Insert key when you want to add a record to your files. This will open a screen to enter your data. EDITING A RECORD Music & Video Librarian V 3.8 Page 45 ====================================================================== <Enter>:..First highlight the record you wand to edit and press <Enter>. The screen will look different than when you add a record. An '==>' is visible at the first field. Using the arrow keys move to the field you want to edit and press <Enter>. This will allow you to edit the field. Press <Enter> again and the '==>' will re-appear. Edit all the fields you need and press <ESC> to accept, re-try, or cancel you edits. DELETING A RECORD <DEL>:..Highlight the record you want to delete and press the <DEL> key. The following fields are contained in the Media Table. Media ----- Format: 12 position character field Contents: Enter the album media for this album. Pressing enter is this field will pop up a menu of default media's that you can select from by moving the up and down arrow keys. When you find the media you desire press enter and it will be placed into the field for you. The following media's came as default with the software: ALBUM CD DAT EP SINGLE 45 78 CASETTE TAPE OTHER You can add additional entries either by entering the new category in this field or by using the TABLES menu and selecting MEDIA. Please refer to the MEDIA later in this manual on how to add change or delete records from this file. Page 46 Music & Video Librarian V 3.8 ====================================================================== Category Validation Table ========================= ┌─────────────────────────────────────┐ │ Category Table Maintenance │ ├─────────────────────────────────────┤ │ Category Code.. ■■■■■■■■■■■■ │ │ │ └─────────────────────────────────────┘ This is the screen used to make changes to the Category Table. TO RETURN TO PREVIOUS SCREEN Press <ESC> until a pop-up appears and asks you if you want to EXIT. Pressing <ESC> from any screen in the program will get you back to the previous screen. To exit ir quit the program press <ESC> until you are prompted to exit the program. Selecting this menu option brings up a browse window. If the file is empty, you will automatically be put into a screen for adding your first record. But let's start with the browse window. You only see the first couple of fields when it comes up. By pressing the Arrow keys you can move to the right, left, down, or up in order to see all the records and fields in your databases. Page up, down, home , and end will also move you through the window. While in the Browse you can change the order your data is presented in (we call this indexing). Press F10 to see a pop-up of the indexes available. Use the arrow keys to highlight the one you want and press <Enter>. You can use the arrow keys to move to the field containing the index condition before or after you select the new index. If you want to search for the name of a user, index on the user's name and type in some or all of it. Then press <Enter>. If you only typed in a few letters of the name ('stu', for example), the program will seek the first person whose name starts with 'Stu'. The same hold true for all the indexes. ADDING A RECORD <INS>:..Use the Insert key when you want to add a record to your files. This will open a screen to enter your data. EDITING A RECORD Music & Video Librarian V 3.8 Page 47 ====================================================================== <Enter>:..First highlight the record you wand to edit and press <Enter>. The screen will look different than when you add a record. An '==>' is visible at the first field. Using the arrow keys move to the field you want to edit and press <Enter>. This will allow you to edit the field. Press <Enter> again and the '==>' will re-appear. Edit all the fields you need and press <ESC> to accept, re-try, or cancel you edits. DELETING A RECORD <DEL>:..Highlight the record you want to delete and press the <DEL> key. The following fields are contained in the Category Table. Category -------- Format: 12 position character field Contents: Enter the music catagory for this album. Pressing enter is this field will pop up a menu of default categories that you can select from by moving the up and down arrow keys. When you find the catageory you desire press enter and it will be placed into the field for you. The following categories came as default with the software: ROCK JAZZ FUSION POPULAR NEW WAVE CLASSICAL SOUND TRACK COUNTRY VINTAGE You can add additional entries either by entering the new category in this field or by using the TABLES menu and selecting CATEGORY. Please refer to the category later in this manual on how to add change or delete records from this file. Page 48 Music & Video Librarian V 3.8 ====================================================================== Utilities ========= The Utilities menu is used to select general purpose functions that are not directly releted to the Music and Video Librarian. When this menu item is selected the following menu will appear: ╔═══════════════════════════╗ ║ Free Form Report Generator║ ║ Reorganize/Sort ║ ║ Set Screen Colors ║ ║ Set Printer ║ ╚═══════════════════════════╝ These functions include: Free Form Report Generator Allows you to design and print your own reports. Reorganize/Sort Rebuilds and optimizes all the files. Set Screen Colors Set screen colors to your own likings. Add/Change Printer Configurations Setup printer configuration for your printer. Music & Video Librarian V 3.8 Page 49 ====================================================================== Free Form Report Generator ========================== Each report is based on a primary database you select from a window. You select the fields you want in the report, specify upper and lower limits of field values to select for the report, and you select a printer configuration. If the configuration you want does not exist, you can add a new one. You can define as many reports as you want for each file. All reports print in a columnar format with headings. Based on the printer configuration you select, an effort will be made to print one record per line by switching between print sizes and types. If a complete record does not fit on one line, it will wrap to the next line between two fields. SAMPLE USAGE ============ First, highlight "User-Defined Reports" and press [Enter]. You will see the following screen with the heading "List of Files". These are all the databases in Music and Video Librarian: ╔═════════════════════════╗ ║ List of Files ║ ╠═════════════════════════╣ ║ File Title ║ ╟─────────────────────────╢ ║Music Albums ║ ║Category Validation Table║ ║Hi-Fi & Video Equipment ║ ║Media Validation Table ║ ║Set Printer ║ ║Radio Station Directory ║ ║Album Songs ║ ║Video Library ║ ╚═════════════════════════╝ For now, let's say you want a print-out of all the records in the Music file with a Category of "ROCK" Highlight "Music Albums" and press [Enter]. The bottom of the screen will ask you to 'Enter report title or esc. to cancel', type in 'Rock Music' and press [Enter]. It will then ask for the 'Printer Configuration ID for this report', type in any three-letter ID defined in the Printer Setup Utility (CIT will work with most Dot Matrix printers), then press Page 50 Music & Video Librarian V 3.8 ====================================================================== [Enter]. If you are not sure what printer to use press [enter] and the following screen will appear: ╔═════════════════════════════════════╗ ║ Printer Configurations ║ ╠══════╤══════════════════════════════╣ ║Prt ID│ Printer ID Title ║ ╟──────┼──────────────────────────────╢ ║CIT │Citizen MSP-10/20 ║ ║HP │Hewlett Packard Laser Jet II ║ ║IBM │IBM Proprinter ║ ║OTC │Output Technologies ║ ╚══════╧══════════════════════════════╝ Using the arrow keys either move up or down and highlight the printer you are using and press [enter]. If your printer is not on this table then go to the Utility menu and define your printer. After doing this, your screen will be a list of reports for "Music Albums". ╔════════════════════════════════════════════════╗ ║ List of Reports for Music Albums ║ ╠════════════════════════════════════════╤═══════╣ ║ Report Title │Printer║ ╟────────────────────────────────────────┼───────╢ ║Rock Music │CIT ║ ╚════════════════════════════════════════╧═══════╝ It should be the only one there, so highlight it and press [Enter]. This will bring up a "List Of Fields" screen. These are all the fields in the "Music Albums" database. ╔══════════════════════════════════════════╗ ║ List of Fields ║ ╠══════════════════════════════╤════╤══════╣ ║ Field Title │Type│Length║ ╟──────────────────────────────┼────┼──────╢ ║Album Number │N │ 6║ ║Title of Album │C │ 50║ ║Artist or Group │C │ 40║ ║Album Media │C │ 8║ ║Category of Music │C │ 12║ ║Date Purchased │D │ 8║ ║Cost of Album │N │ 6║ ║Album Label │C │ 20║ ╚══════════════════════════════╧════╧══════╝ Music & Video Librarian V 3.8 Page 51 ====================================================================== Highlight "Title of Album" and press [Enter]. A "Field Definition" screen will appear. "Title of Album" will be the only one there, press [enter]. The screen will ask you for the lower and upper limit. This is a way to filter out unwanted records. Press [Enter] two times. Now we're back at the "List Of Fields" screen, press [Ins] to add a new field. Using the down arrow key, highlight "Category" and press [Enter]. Now we're at the "Field Definition", select "Category" and press [Enter] again. This is where we'll filter out the unwanted records. All we want are records for "Category" = "ROCK" Therefore, in 'Lower Limit' type ROCK, in the upper limit type ROCK. This will only report on ROCK items. Now add the rest of the fields you want included in the report by using the [Ins] key and doing the same things that you already did. UPPER AND LOWER LIMIT ===================== If you wanted a report listing all the names in the files up to, and including, those starting with the letter 'P'. Type 'A' in lower limit and 'P' in upper limit. Or if you only wanted all the Smith's listed, type 'Smith' in both lower and upper limits. That's it, we're finished. Press [ESC]. The program will ask you if you want to print the report now. ┌>Print Report Now?<┐ │ Yes │ │ No │ └───────────────────┘ Highlight 'Yes' or 'No' and press [enter]. If you have reports already defined and want to print one of them. Select the database the report was defined from and press [Enter]. Then select the report you defined and press [Enter]. And at the "Field Definition" screen, press [ESC]. Page 52 Music & Video Librarian V 3.8 ====================================================================== Reorganize/Sort =============== From time to time the files in the Music and Video Librarian muse be reorganized and sorted. If you find that you have lost some records (maybe you turned off your machine or had a power failure) then this function can be used to rebuild all the indexes in the system. This function will also optimize disk space by unused space from the files (when records are deleted the disk space that they occupy does not go away) If any of the following situations occur then it is time to sort the files: It appears that records seem to be missing from one or more files. You have been deleting a lot of records. You have been changing a lot of records. This process should only take a few minutes depending on the size (number of recrods) of your files. You will see messages indicating progress as the sorting is processing. Music & Video Librarian V 3.8 Page 53 ====================================================================== Set Screen Colors ================= This selection will let you change the color settings for the screens, and if you want windows to explode and implode. When you select this item the following screen will appear: ╓───────────────────────────────────────────────────╖ ║ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ║ ║ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ║ ║ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ║ ║ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ║ ║ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ║ ║ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ║ ║ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ║ ║ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ■ ║ ║ ║ ╟───────────────────────────────────────────────────╢ ║ ══>Graphics.........: Cyan on Black ║ ║ Data Fields......: Bright Cyan on Black ║ ║ Enhanced.........: Yellow on Blue ║ ║ Screen Text......: Bright Red on Black ║ ║ Exploding Windows: Y ║ ╙───────────────────────────────────────────────────╜ Selecting different colors for your program is simple. First, move the edit arrow next to the area you want to re-set the colors for (GRAPHICS, DATA FIELDS, ENHANCED, or SCREEN TEXT), then press [Enter]. Using the arrow keys to select a color combination, move the edit arrow "══" to the left of the color you want to select, then press [Enter]. A sample of the color combination will appear in the field for which it has been chosen. When you have completed making your selections press [ESC] to exit and save your changes. Graphics ======== Graphics characters include menu boxes and screen borders. Data Fields =========== Data fields are the regions of data input on the screen normally in reverses video. For example, if you go to the inventory screen and either view a record or add a new record you will see that fields that you must enter data into are in reverse video. Enhanced Page 54 Music & Video Librarian V 3.8 ====================================================================== ======== This changes the colors of the SELECTED menu choices and other highlight bar options. Screen Text =========== Screen text is the area of the screens used to identify the fields. For example, if you go to the Music Albums and either view a record or add a new record you will see that fields have identifiers like "Title" or "Category". These areas of the screen cannot be modified but you can change there color. Exploding Windows ================= This is a YES/NO option. It is used to determine whether or not your application will have windows that explode onto the screen or sneak into view. Music & Video Librarian V 3.8 Page 55 ====================================================================== Set Printer =========== ┌────────────────────────────────────────────────────────────────────────┐ │ Printer setup/Configuration Utility │ ├────────────────────────────────────────────────────────────────────────┤ │ Configuration ID..... ■■■ │ │ Printer Description.. ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ │ │ Network Printer No... ■ │ │ Reset String......... ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■│ │ │ │ Setup string Width Len │ │ -------------------------------------------------- ----- --- │ │Level 1 ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ■■■ ■■■ │ │Level 2 ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ■■■ ■■■ │ │level 3 ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ■■■ ■■■ │ └────────────────────────────────────────────────────────────────────────┘ The Printer Setup Utility will allow you to define your own printer configurations for Music and Video Librarian. Four standard configurations come standard with the product The Printer Setup Utility is used by both the Free Form Report generator and reports that need more than 80 characters to print, such as the wide reports. The Printer Setup Utility is selected directly from the submenu of MISC. When you are ready to use this function, highlight PRINTER SETUP, then press [enter]. Once selected, the list of printer configurations will appear. The software uses three different setup strings to determine how to lay out lines of text before the actual printing begins. These strings also determine when a page is full and when to skip to the next page, and finally what codes (escape sequences) need to be sent to the printer also. The software will automatically select the proper setup string and page size that best fits the report. If one line of the report will fit in the width specified by WIDTH 1, the level 1 Setup String will be used. If the line of the report is too wide for the level 1 Width, but less than or equal to the Level 2 Width, the Level 2 Setup String will be used. If the line of the report is too wide for the level 2 Width, but less than or equal to the Level 3 Width, the Level 3 Setup String will be used. If the report is still too wide, the software will utilize more than one line on the page per printed record printed, and will print on each line as many fields as will fit without breaking, Page 56 Music & Video Librarian V 3.8 ====================================================================== and then will wrap to the next line. If a line has to wrap to the next line, the software will adjust the number of lines per page to compensate for the fact that fewer records will fit on a page. You can force the software to use the same Setup String, Width and Line all the time by setting all three levels to the same value. This is a good idea when you are using 80 column paper in a 130 column printer. Printer Setup Strings ===================== To follow along with this example, you need to select the printer with the configuration ID of "HP", printer name "Hewlett Packard Laser Jet II" from the list of printer configurations. Once selected, read the following explanation of the Level 1, Level 2, Level 3, Width and Length Fields. Notice the /027 in each of the Setup Strings and the Reset String. Anytime you want to include a character in a string that cannot be entered through the keyboard, you can enter a backslash followed by the character's ASCII value. You MUST use three positions for the ASCII value even if is is less than 100. On a Hewlett Packard Laser Printer, the Escape key, which acts as a control character, has an ASCII value of 27. /027 was entered because three positions need to be filled. This value (/027) tells the printer that the text to follow is not to be printed, but is to interpreted as configuration information The Level 1 Setup String tells the software to set the printer to Courier font, that 80 characters will fit on one line and that no more than 55 lines of the page will be used. The Level 2 Setup String tells the software to switch to the 16.6 characters per inch Pica font and that 130 characters will fit on one line. The Level 3 Setup String tells the software to remain at 16.6 characters per inch, but to switch to Landscape (sideways) printing. Now, 170 characters will fit on one line (Width = 170) and the page length will be reduced (Length = 40). If you need additional help in setting up your printer configuration please give us a call at our Technical Support number listed in the front of the Users' Guide. Printer ID ---------- Music & Video Librarian V 3.8 Page 57 ====================================================================== Format: 3 position character field Contents: This field is a unique identifier that you will assign to each new configuration. When you want to print a report you simply add the configuration ID number that corresponds to the printer that you will be used to print the report. Printer Name ------------ Format: 30 position character field Contents: Used this field to enter a brief description of the printer that this configuration will be set for. The easiest description in the brand and type of printer. If there are several printers that are the same brand and type, you need an additional identifier such as a number or letter appended to this field. ALSO, if more than one configuration will be set up for the SAME printer, it is advisable that the description entered be such that it will be easy to identify the features the individual configurations have. Network Printer Number ---------------------- Format: 1 position numeric field Contents: This field is the printer that all reports with this configuration should be routed to. If the software is running on a Novell network, this number would correspond to the network-assigned printer number, where the first network printer is number 1, the second network printer is number 2 and so on. If the software will be running on a stand-alone PC, or if the reports with this configuration are to be routed to a printer connected to the first parallel printer port on the PC, the Network Printer Number should be set to 0 (zero). Page 58 Music & Video Librarian V 3.8 ====================================================================== Printer Reset Sequence ---------------------- Format: 50 position character field Contents: This field is used to enter setup strings to reset the printer back to the "Normal" state. Please refer to the example above for a full use of this field. Printer Level 1 --------------- Format: 50 position character field Contents: This field is used to enter setup strings. Please refer to the example above for a full use of this field. Printer Width ------------- Format: 3 position numeric field Contents: This field is used to specify the number of characters that can be printed on a single line for your printer. Printer Page Length ------------------- Format: 3 position numeric field Contents: This field is used to specify the number of lines that can be printed on a single page. Printer Level 2 --------------- Format: 50 position character field Contents: This field is used to enter setup strings. Please refer to the example above for a full use of this field. Music & Video Librarian V 3.8 Page 59 ====================================================================== Printer Width ------------- Format: 3 position numeric field Contents: This field is used to specify the number of characters that can be printed on a single line for your printer. Printer Page Length ------------------- Format: 3 position numeric field Contents: This field is used to specify the number of lines that can be printed on a single page. Printer Level 3 --------------- Format: 50 position character field Contents: This field is used to enter setup strings. Please refer to the example above for a full use of this field. Printer Width ------------- Format: 3 position numeric field Contents: This field is used to specify the number of characters that can be printed on a single line for your printer. Printer Page Length ------------------- Format: 3 position numeric field Contents: This field is used to specify the number of lines that can be printed on a single page. Page 60 Music & Video Librarian V 3.8 ====================================================================== Manual/Registration =================== If you are using a Shareware version of the Music and Video librarian and would like to register it then you can use this menu item to view and print out a registration from. Dont forget to turn your printer on. Music & Video Librarian V 3.8 Page 61 ====================================================================== View/Print Manual ================= █████████████████████████████████████████████████████████████ █ █ █ This option will print out the user's manual. It is █ █ best to use tractor feed paper and your printer must █ █ be able to print ASCII characters. This manual will █ █ take about 70 pages to print. █ █ █ █ >>>> Please make sure your printer is on and ready <<<< █ █ █ █████████████████████████████████████████████████████████████ View or Print the User Manual Page 62 Music & Video Librarian V 3.8 ====================================================================== View/Print Registration ======================= View and/or Print the Registration Form Music & Video Librarian V 3.8 Page 63 ====================================================================== Options ======= ╔════════════════════════════════════════════════════════════════════╗ ║ System Parameters ║ ╟────────────────────────────────────────────────────────────────────╢ ║ Name........ ■■■■■■■■■■■■■■■■■■■■ ║ ║ Address..... ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ City, St ZIP ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ║ Phone....... ■■■■■■■■■■■■■ ║ ╟────────────────────────────────────────────────────────────────────╢ ║ Printer Id.. ■■■■ ║ ║ Desc........ ■■■■■■■■■■■■■■■■■■■■■■■■■■■■■■ ║ ╚════════════════════════════════════════════════════════════════════╝ (This procedure may be accessed by pressing hotkey F6.) The options file is used collect options that will be used on most of the standard functions of the Music and Video Librarian. This function can be selected by pressing the [F6] from anywhere in the software without disrupting what function you are currently doing. Name ---- Format: 30 Character field Contents: Enter your full name. This field is used on some of the reports, such as insurance reports, to identify the owner of the data. Suggest using first, middle initial, and last name. Address ------- Format: 30 character field Contents: Enter your street address, and apartment number or other address information. City, State ZIP --------------- Page 64 Music & Video Librarian V 3.8 ====================================================================== Format: 30 character free form field Contents: Enter your city, state, and zip code. Example: Plano, TX 75023 Phone Number ------------ Format: 30 character, free form, not required Contents: Enter your home phone number Example (214) 555-1212 Printer Id ---------- Format: 3 position character field Contents: This field is a unique identifier that you will assign to each new configuration. When you want to print a report you simply add the configuration ID number that corresponds to the printer that you will be used to print the report. Printer Name ------------ Format: 30 position character field Contents: Used this field to enter a brief description of the printer that this configuration will be set for. The easiest description in the brand and type of printer. If there are several printers that are the same brand and type, you need an additional identifier such as a number or letter appended to this field. ALSO, if more than one configuration will be set up for the SAME printer, it is advisable that the description entered be such that it will be easy to identify the features the individual configurations have. Music & Video Librarian V 3.8 Page 65 ====================================================================== Help Topics =========== (This procedure may be accessed by pressing hotkey F2.) The help topics will provide for you an easy to use online manual. In fact all the information that is contained in the paper manual is available thru the use of help topics. When you select this item using the [F2] the following menu will appear: ╔═════════════════════════════════════════╗ ║ Help Topics File ║ ╠══════════════════════════════════╤══════╣ ║ Help Title │Hotkey║ ╟──────────────────────────────────┼──────╢ ║Music and Video Librarian │ ║ ║Data Entry │ ║ ╚══════════════════════════════════╧══════╝